Description : Data Analyst. Company : Sanlam. Location : Bellville, Western Cape
Who we are?
Sanlam Investments Group is one of South Africa’s largest investment management companies. We have a performance history spanning over 100 years, and offer a range of investment and financial planning solutions to protect and grow the long-term wealth of our clients.
We take particular pride in:
- Sanlam’s longevity and innovation
- People, teamwork and values
- A culture of diversity and commitment to growing our own timber
- Our robust, tested and proven pragmatic investment process and philosophy
Sanlam Collective Investments (South Africa) was established in 1967 as a full Sanlam subsidiary. Sanlam Collective Investments manages funds of about R215 billion on behalf of more than 238 000 investors. Other renowned financial services companies have also partnered with us to offer third-party funds. In these cases, the third-party funds are distributed and promoted by the respective financial services companies, whereas Sanlam Collective Investments is responsible for the client administration and compliance About the position?
The data stream at Sanlam Collective Investments requires a Data Analyst with ETL and reporting skills to compliment the existing Data stream. The Data stream is responsible for data quality, data integrity, security, audit information and producing exception reports and to produce tools and dashboards, both operational and on tabular models. The data stream also signs off on the architectural design and integration into other platforms within the business and provides input into groupwide data excellence programs.
The Data Analyst will identify opportunities for improvement in data quality and integrity and build health check and exception reports supporting specific business questions and strategies. The data analyst with be expected to write complex data queries to investigate and solve business queries and suggest and build long-term solutions to ensure better data integrity and processes over time.
The role will include occasional after-hours work.
Key responsibilities
Perform data analyses on data to support specific data questions and provide either once off or scheduled reports to business to improve processes. Identify data integrity and quality gaps and propose solutions Ensure adequate controls are built into business processes to ensure data integrity over time Investigate and resolve data issues logged and raised via the support team within agreed timeframes Closely working with business teams, development team, vendors and testers to ensure requirements are delivered in an expected format Supporting the business with regards to business and process improvements Provides inputs into training manuals and assists with transfer of knowledge to end users and trainers Facilitation of meetings, workshops, etc. to gather information Working with key service providers to ensure business requirements, business rules and controls are documented and signed off Translate business requirements into solutions Ensure appropriate documentation is created and maintained Ability to perform process mapping and design Provide input into test plans and test cases Behavioural competencies:
Meticulous attention to detail, with a commitment to follow through and follow-up Willingness to learn and share knowledge Ability to work independently and shows initiative Time management and organizational skills Resilience and the ability to adapt well under stress Ability to be an effective team player and proactive individual Must be able to communicate effectively with technical and non-technical audiences and interact with all types of clients including technology, business, management and executive management Analytical, innovative and demonstrates initiative Good communication skills both written and verbal Good interpersonal and facilitation skills Ability to collaborate and pull information together
Technical competencies:
Good understanding of the software development lifecycle, both waterfall and agile Solid SQL knowledge Solid knowledge of SSRS, SSMS and SSIS Strong Excel knowledge using excel formulas Knowledge of Power BI Advantageous: knowledge of ETL and working with tabular models using Dax (will be developed) Experience working within a fast-paced and dynamic business environment (advantageous) Ability to transfer knowledge to users, trainers and peers Ability to package and present analysis with recommendations to management and executive teams Strong facilitation skills for meetings, workshops and forums Minimum requirements:
Matric and relevant tertiary qualification Experience in data analyses and BI tools relevant (SQL) Minimum of 2 - 3 years’ experience in a data analyst, BI analyst or similar role Collective Investment Schemes experience is essential
Build a successful career with us
We’re all about building strong, lasting relationships with our employees. We know that you have hopes for your future – your career, your personal development and of achieving great things. We pride ourselves in helping our employees to realise their worth. Through its four business clusters – Sanlam Life and Savings, Sanlam Investment Group, Sanlam Emerging Markets, Santam, as well as MiWay and the Group Office – the group provides many opportunities for growth and development. Turnaround time
The shortlisting process will only start once the application due date has been reached. The time taken to complete this process will depend on how far you progress and the availability of managers. Our commitment to transformation
The Sanlam Group is committed to achieving transformation and embraces diversity. This commitment is what drives us to achieve a diverse, inclusive and equitable workplace as we believe that these are key components to ensure a thriving and sustainable business in South Africa. The Group's Employment Equity plan and targets will be considered as part of the selection process.
